﻿<?php

mysql_connect('projecttus.com', 'projectt_fernando','20100730');
mysql_selectdb('projectt_fernando');


mysql_query("
CREATE TABLE IF NOT EXISTS `caf02` (
  `caf02_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf02_cod_user` int(2) NOT NULL,
  `caf02_date` datetime NOT NULL,
  `caf02_mesa` int(4) NOT NULL,
  `caf02_group` int(4) NOT NULL,
  `caf02_active` int(11) NOT NULL,
  PRIMARY KEY (`caf02_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=559 ;

INSERT INTO `caf02` (`caf02_cod`, `caf02_cod_user`, `caf02_date`, `caf02_mesa`, `caf02_group`, `caf02_active`) VALUES
(558, 2, '2010-07-31 04:45:08', 4, 4, 1);

CREATE TABLE IF NOT EXISTS `caf03` (
  `caf03_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf03_menu` varchar(100) NOT NULL,
  PRIMARY KEY (`caf03_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

INSERT INTO `caf03` (`caf03_cod`, `caf03_menu`) VALUES
(1, 'Pizza'),
(2, 'Soft Drinks'),
(3, 'Doces'),
(4, 'Salgados'),
(5, 'Cafes'),
(6, 'Pastas'),
(7, 'Destilados'),
(8, 'Cervejas'),
(9, 'Cockteis');

CREATE TABLE IF NOT EXISTS `caf04` (
  `caf04_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf04_cod_menu` int(11) NOT NULL,
  `caf04_cod_prod` int(11) NOT NULL,
  `caf04_qtd` int(11) NOT NULL,
  `caf04_cod_item` int(11) NOT NULL,
  `caf04_coment` text NOT NULL,
  PRIMARY KEY (`caf04_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=477 ;

INSERT INTO `caf04` (`caf04_cod`, `caf04_cod_menu`, `caf04_cod_prod`, `caf04_qtd`, `caf04_cod_item`, `caf04_coment`) VALUES
(1, 1, 12, 1, 430, 'UYYNN MM,.'),
(2, 1, 12, 1, 430, 'UYYNN MM,.'),
(476, 1, 3, 1, 558, '');

CREATE TABLE IF NOT EXISTS `caf05` (
  `caf05_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf05_prod` varchar(100) NOT NULL,
  `caf05_cod_menu` int(11) NOT NULL,
  `caf05_valor` int(11) NOT NULL,
  `caf05_car` text NOT NULL,
  PRIMARY KEY (`caf05_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;

INSERT INTO `caf05` (`caf05_cod`, `caf05_prod`, `caf05_cod_menu`, `caf05_valor`, `caf05_car`) VALUES
(1, 'Coca-cola', 2, 6, 'Lata'),
(2, 'Pepsi', 2, 3, '600ml'),
(3, 'Calabresa', 1, 7, 'Large'),
(4, 'Muzzarela', 1, 77, 'Medium'),
(5, 'Portuguesa', 1, 88, 'Large'),
(6, 'Muzzarela', 1, 44, 'Small'),
(7, 'California', 1, 44, 'Small'),
(8, 'Fanta', 2, 66, 'Copo'),
(10, 'Portuguesa', 1, 12, 'Medium'),
(11, 'Portuguesa', 1, 23, 'Small'),
(12, 'Calabresa', 1, 12, 'Small'),
(13, 'Coca-Cola', 2, 345, '600ml'),
(14, 'Coca-Cola', 2, 11, 'Copo'),
(15, 'Spicy', 1, 22, 'Small'),
(16, 'Spicy', 1, 223, 'Medium'),
(17, 'Marinara', 1, 2342, 'Small'),
(18, 'Marinara', 1, 234, 'Medium'),
(19, 'Spicy', 1, 123, 'Large'),
(20, 'Marinara', 1, 2, 'Large');

CREATE TABLE IF NOT EXISTS `caf06` (
  `caf06_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf06_ingred` text NOT NULL,
  `caf06_met` text NOT NULL,
  `caf06_valor` text NOT NULL,
  PRIMARY KEY (`caf06_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `caf06` (`caf06_cod`, `caf06_ingred`, `caf06_met`, `caf06_valor`) VALUES
(1, 'Calabresa', 'un', '12');

CREATE TABLE IF NOT EXISTS `caf07` (
  `caf07_cod` int(11) NOT NULL AUTO_INCREMENT,
  `caf07_ingred` text NOT NULL,
  PRIMARY KEY (`caf07_cod`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

INSERT INTO `caf07` (`caf07_cod`, `caf07_ingred`) VALUES
(1, 'Etanol'),
(2, 'Pinga'),
(3, 'Abacaxi');

CREATE TABLE IF NOT EXISTS `caf08` (
  `caf08_cod_ing` text NOT NULL,
  `caf08_cod_ped` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `caf08` (`caf08_cod_ing`, `caf08_cod_ped`) VALUES
('1', '536');

CREATE TABLE IF NOT EXISTS `caf09` (
  `caf09_cod_prod` int(11) NOT NULL,
  `caf09_cod_ing` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `caf09` (`caf09_cod_prod`, `caf09_cod_ing`) VALUES
(3, 1),
(4, 2);

");

?>
